Creating a Query
This topic
describes how to create a basic query.
To create a query using advanced mode, see Creating a Query with Advanced Mode.
Follow these steps to create a query.- Open Queries.
-
Click to expand
My Queries context menu (
), and then select
+ Create New Query.
The Create New Query dialog appears.
- Enter the Query Name, and then click Ok. The query name appears in the My Queries list.
-
Click
Define Query.
The Query Builder dialog opens.
- Select a Schema from the drop-down list. For example,
-
Select a Class from the drop-down list.
For example,
To create a query with Where Clause, see Creating a Query with the Where Clause.
To create a query with Advanced Mode, see Creating a Query with Advanced Mode.
- To add another Class, click + New , and then select a Schema and Class from the drop-down list. The Class is added to the query.
- Repeat step 7, to add more new classes.
- (Optional) To delete a Class, first select the Class and then click Remove.
- (Optional) To move a Class one position up in the hierarchy, first select the Class and then click Up.
- (Optional) To move a Class one position down in the hierarchy, first select the Class and then click Down.
- When you are finished, click Save. The query is generated based on the parameters you have specified, and the qualifying records appear in grid format. For example,